https://store-images.s-microsoft.com/image/apps.14811.8c3deb93-7dcf-42d3-af7f-8520f726b67a.8ef870f0-c766-43cd-8140-c6d671402bf8.76cc9b70-0c6f-435f-a238-ca9529b1b324

JP Morgan Bank Integration

by d365.Global Pty Ltd

Used to export PAIN files using SFTP, Encrypt files, Bank Account Reconciliation

J P Morgan Bank integration with azure storage for exporting payment files or import bank statement for bank account reconciliations.

Integrated with azure storage, the extension can be used to export PAIN files, i.e. export bank payment files to azure SFTP, encrypt the file as per bank format, import bank statement for bank account reconciliation on a daily basis.
This solution involves the secure exchange of payment files from Business Central to JP Morgan via Azure containers and encrypted using PGP. Additionally, statement CAMT files are received from JP Morgan, decrypted, and imported into the relevant bank accounts in Business Central instance.​


Architecture​

Business Central Overview​

  • Payment Journal (Pain)​

      • Business Central Payment Journal generates pain.001 format files under Business Central instance.​
      • Payment file is based on vendor bank account selection in payment journal.​
      • Mandatory checks are done before generating, like date must be always today, bank account no., IBAN no., city, country should be present.​
      • System checks if the file has already been exported if it is system will alert user if they want to again export the file.​
      • After successful export user can preview post the document in business central or post the document for accounting purpose.​
      • Duplicate checking is based on:​
        • #Total​
        • No of Transactions​

​

  • Statement (CAMT) (JP Morgan to Client (BC)):​

      • Bank reconciliation.​
      • You can import the CAMT or Bank statement file into bank reconciliations via manually uploading the statement or importing it directly from container where bank has uploaded the statement.​
      • Bank reconciliation can be done daily as per the statement received from bank or can be done monthly, there is flexibility based on statement received from bank.​
      • After importing the statement business central can auto match the transactions based on description, amount. User can also manually match the statement line with bank ledger into system.​
      • Once the balance has matched with statement, user needs to post the bank reconciliation.​

At a glance

https://store-images.s-microsoft.com/image/apps.61412.8c3deb93-7dcf-42d3-af7f-8520f726b67a.8ef870f0-c766-43cd-8140-c6d671402bf8.51fa470b-4336-4627-8178-97f90990e07c
https://store-images.s-microsoft.com/image/apps.15967.8c3deb93-7dcf-42d3-af7f-8520f726b67a.8ef870f0-c766-43cd-8140-c6d671402bf8.d17ed056-34f3-4bf7-ab33-230b2525e40b
https://store-images.s-microsoft.com/image/apps.32315.8c3deb93-7dcf-42d3-af7f-8520f726b67a.8ef870f0-c766-43cd-8140-c6d671402bf8.f5211d38-c2b6-4337-86a3-bd5a048601fc